#    Copyright 2008, 2009 Tri-County Electric Cooperative, St. Matthews, South Carolina
#    This file is part of COOPGIS.
#    COOPGIS is free software: you can redistribute it and/or modify
#    it under the terms of the GNU General Public License as published by
#    the Free Software Foundation, either version 3 of the License, or
#    (at your option) any later version.
#    COOPGIS is distributed in the hope that it will be useful,
#    but WITHOUT ANY WARRANTY; without even the implied warranty of
#    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
#    GNU General Public License for more details.
#    You should have received a copy of the GNU General Public License
#    along with COOPGIS.  If not, see <http://www.gnu.org/licenses/>.

#************************BEGIN Add Include Files to Path************************
import sys
NeededPaths=['/opt/coopgis/djangoproject/include', '/opt/coopgis/djangoproject']
for path in NeededPaths:
    if(not path in sys.path):
        sys.path.append(path)
#************************END   Add Include Files to Path************************
import COOPGIS_Ajax, COOPGIS_GPS, COOPGIS_Misc, COOPGIS_ReportLab, COOPGIS_String, COOPGIS_Update, COOPGIS_FormJointUseEditor
import COOPGIS_FormMisc, COOPGIS_FormGeography
import os, csv, shutil, datetime, time, reportlab, djangoproject.settings, random
from django.contrib.gis.db import models
from django.contrib.gis.geos import *
from django.http import HttpResponse
from django.contrib import admin
from django.template import Context, loader
import djangoproject.settings
import _mysql as mysql
from models import *
from django import forms

def JointUseEditor(request):
    ApplicationName=djangoproject.settings.COOPGISJointUseEditorApplicationName
    UserNameOrIPAddress, DefaultMap=COOPGIS_Misc.GetUserNameOrIPAddress(request, GetDefaultMap=True, ApplicationName=ApplicationName)
    LoginStatus, applicationPermission=COOPGIS_Misc.CheckLoginPermissions(request, ApplicationName)
    form=COOPGIS_FormMisc.BuildForm(request, ApplicationName, DefaultMap) 
    if(not applicationPermission): #Show view of Map and Form if no Permissions, do not perform any form processing
        MapFileName, LayerName=COOPGIS_Misc.GenerateDynamicMapFile(ApplicationName, UserNameOrIPAddress)
        OpenLayersZoom=COOPGIS_Ajax.GetOpenLayersZoom(None, None)
        t = loader.get_template('/opt/coopgis/djangoproject/templates/jointuseeditor.html')
        c = Context({'OpenLayersZoom': OpenLayersZoom, 
                     'MapFileName': MapFileName, 'LayerName': LayerName, 'LoginStatus':LoginStatus})
        return HttpResponse(t.render(c))
    SelectionStation, SelectionSpan, GPSStatus=COOPGIS_FormGeography.SetSelectionStationAndSpan(form)
    COOPGIS_FormGeography.GetAndSetDefaultMap(form, ApplicationName, UserNameOrIPAddress)
    OpenLayersZoom=COOPGIS_Ajax.GetOpenLayersZoom(SelectionStation, SelectionSpan)
    COOPGIS_FormJointUseEditor.ProcessJointUseEditorForm(form, SelectionStation, UserNameOrIPAddress)
    form=COOPGIS_FormJointUseEditor.PopulateJointUseEditorForm(form, SelectionStation)
    COOPGIS_Misc.UpdateSelection(SelectionStation, SelectionSpan, UserNameOrIPAddress)
    MapFileName, LayerName =COOPGIS_Misc.GenerateDynamicMapFile(ApplicationName, UserNameOrIPAddress)
    OpenLayersJavaScriptHeading=COOPGIS_Ajax.GetOpenLayersJavaScriptHeading()
    OpenLayersJavaScript=COOPGIS_Ajax.GetOpenLayersJavaScript(OpenLayersZoom, MapFileName, LayerName)

    t = loader.get_template('/opt/coopgis/djangoproject/templates/jointuseeditor.html')
    c = Context({'form': form,
                 'LoginStatus':LoginStatus, 
                 'GPSStatus':GPSStatus,
                 'OpenLayersJavaScript': OpenLayersJavaScript,
                 'OpenLayersJavaScriptHeading': OpenLayersJavaScriptHeading})
    return HttpResponse(t.render(c))


def JointUseReport(request):
    ApplicationName=djangoproject.settings.COOPGISJointUseEditorApplicationName
    UserNameOrIPAddress=COOPGIS_Misc.GetUserNameOrIPAddress(request, GetDefaultMap=False, ApplicationName=ApplicationName)
    LoginStatus, applicationPermission=COOPGIS_Misc.CheckLoginPermissions(request, ApplicationName)
    if(not applicationPermission):
        t = loader.get_template('/opt/coopgis/djangoproject/templates/jointuseeditorreport.html')
        c = Context({'LoginStatus':LoginStatus})
        return HttpResponse(t.render(c))
    PoleJointUses1=PoleJointUseReport(djangoproject.settings.COOPGIS_StMatthewsCircuits)
    PoleJointUses2=PoleJointUseReport(djangoproject.settings.COOPGIS_SanteeCircuits)
    PoleJointUses3=PoleJointUseReport(djangoproject.settings.COOPGIS_RichlandCircuits)
    PoleJointUsesAll=PoleJointUseReport([], False)
    t = loader.get_template('/opt/coopgis/djangoproject/templates/jointuseeditorreport.html')
    c = Context({'PoleJointUses1': PoleJointUses1, 'PoleJointUses2': PoleJointUses2, 'PoleJointUses3': PoleJointUses3,
                     'PoleJointUsesAll': PoleJointUsesAll, 'LoginStatus':LoginStatus})
    return HttpResponse(t.render(c))


def PoleJointUseReport(Circuits, Include=True):
    CurrentResults = {}  #Dictionary in Form CompanyName: of Joint Uses
    All=PoleJointUse.objects.all()
    for poleJointUse in All:
        if(Include):
            for circuit in Circuits:
                if(Assembly.objects.filter(Station=poleJointUse.Station).filter(CircuitNumber=circuit).count()):
                    AddPoleJointUseToCurrentResults(poleJointUse, CurrentResults)
                    break
        else:
            AddPoleJointUseToCurrentResults(poleJointUse, CurrentResults)
    PoleJointUses=[]
    for i in CurrentResults:
        PoleJointUses.append(i + ':  ' + str(CurrentResults[i]))
    PoleJointUses.sort()
    return PoleJointUses


def AddPoleJointUseToCurrentResults(poleJointUse, CurrentResults):
    try:
        CurrentResults[poleJointUse.Company.Name] = CurrentResults[poleJointUse.Company.Name] + 1
    except:
        CurrentResults[poleJointUse.Company.Name] = 1


